DELETE FROM dbo.USERGROUP 
DBCC CHECKIDENT (USERGROUP,RESEED, 0)

INSERT INTO [aircond].[dbo].[USERGROUP]
           ([createDate]
           ,[createUser]
           ,[updateDate]
           ,[updateUser]
           ,[version]
           ,[description]
           ,[groupName])
     VALUES
           ('2013-01-01 00:00:01.000'
           ,null
           ,null
           ,null
           ,1
           ,'ROLE_ADMIN'
           ,'ROLE_ADMIN')
GO

DELETE FROM dbo.USERDETAIL 
DBCC CHECKIDENT (USERDETAIL,RESEED, 0)

INSERT INTO [aircond].[dbo].[USERDETAIL]
           ([createDate]
           ,[createUser]
           ,[updateDate]
           ,[updateUser]
           ,[version]
           ,[active]
           ,[email]
           ,[firstname]
           ,[lastname]
           ,[nickname]
           ,[password]
           ,[phone]
           ,[username])
     VALUES
           (SYSDATETIME()
           ,null
           ,null
           ,null
           ,1
           ,'Y'
           ,null
           ,'SYSTEM'
           ,'ADMIN'
           ,null
           ,'admin'
           ,null
           ,'admin')
GO

INSERT INTO [aircond].[dbo].[USERDETAIL_USERGROUP]
           ([USERDETAIL_ID]
           ,[USERGROUP_ID])
     VALUES
           (1
           ,1)
GO

INSERT INTO [aircond].[dbo].[USERGROUP]
           ([createDate]
           ,[createUser]
           ,[updateDate]
           ,[updateUser]
           ,[version]
           ,[description]
           ,[groupName])
     VALUES
           ('2013-01-01 00:00:01.000'
           ,null
           ,null
           ,null
           ,1
           ,'ROLE_USER'
           ,'ROLE_USER')
GO

INSERT INTO [aircond].[dbo].[USERGROUP]
           ([createDate]
           ,[createUser]
           ,[updateDate]
           ,[updateUser]
           ,[version]
           ,[description]
           ,[groupName])
     VALUES
           ('2013-01-01 00:00:01.000'
           ,null
           ,null
           ,null
           ,1
           ,'ROLE_SUPERVISOR'
           ,'ROLE_SUPERVISOR')
GO

